Would a custom table make more sense than a CPT in this case?

I am building a "multi vendor" type plugin to extend Woocommerce. There will be two types of new user roles: Vendor, and Non-Profit Org.

Vendors can list their products on the site, and users can choose at the checkout page which "Non-Profit Organization" they would like to donate part of their purchase to.

Ultimately, I would like the site owner to be able to have a curated list of all transactions, meaning how much is going to the Non Profit, how much goes to the Vendor. Preferably in chosen increments (monthly, daily, by individual order).

What’s got me stuck is figuring out how to let the "Vendor" and "Non Profit Org" accounts VIEW their respective transactions as well.

I don’t know if I should make two custom post types (Vendor Orders, Non Profit Orders) and just list extra info as Post Meta, as well as finding out a way to make sure ONLY the user assigned to the role can view orders for that role (in other words, one non profit can’t see records of another non profit).

Or, I am wondering if it makes more sense to create a custom table, which lists all valuable information (amount going to vendor, amount going to non profit, etc…) and just write custom queries to list the information based on the current user ID.

Case Converter site lower, UPPER, Capitalized, 7 years domain

I'm selling my website change text case http://generatesitemap.com/
This website will help you easily convert text between different cases, maybe you Accidentally left the caps lock on and typed a text , you can use this tool instead of retyping the text again

Text conversion cases?
you can choose between:
Sentence case
lower case
UPPER CASE
Capitalized Case
aLtErNaTiNg cAsE

Additional Features:
• It uses a light weight script
• Easily to customize and change
• It…

Case Converter site lower, UPPER, Capitalized, 7 years domain

Case Converter site lower, UPPER, Capitalized, 11 years domain

I'm selling my website change text case http://web-design-wiki.com/
This website will help you easily convert text between different cases, maybe you Accidentally left the caps lock on and typed a text , you can use this tool instead of retyping the text again

Text conversion cases?
you can choose between:
Sentence case
lower case
UPPER CASE
Capitalized Case
aLtErNaTiNg cAsE

Additional Features:
• It uses a light weight script
• Easily to customize and change
• It…

Case Converter site lower, UPPER, Capitalized, 11 years domain

Case Converter site lower, UPPER, Capitalized, ….

I'm selling my website change text case http://web-design-wiki.com/
This website will help you easily convert text between different cases, maybe you Accidentally left the caps lock on and typed a text , you can use this tool instead of retyping the text again

Text conversion cases?
you can choose between:
Sentence case
lower case
UPPER CASE
Capitalized Case
aLtErNaTiNg cAsE

Additional Features:
• It uses a light weight script
• Easily to customize and change
• It…

Case Converter site lower, UPPER, Capitalized, ….

Determine third normal form in case of two functional dependencies

Assume I’m given an entity E which has attributes A, B and C, (each of them is a candidate key, but let’s say I can introduce some EID that serves as a PK) with functional dependencies: A determines C and B determines C. How would I get this into a third normal form?

I have tried the following:

E(EID(PK), AID(FK), BID(FK)) A(AID(PK), C) B(BID(PK), C) 

but in this representation, I’m have the attribute C twice in my database. Can anyone advise on a more appropriate way of getting into a third normal form?

What can be a reason of a “The requested URL / was not found on this server” error in case of an addon domain?

Let’s say I have a site hosted on a.example.com. I’m adding an addon domain to the server (shared hosting): b.example.com and point this domain to the server IP address.

Visiting b.example.com provides the same site as a.example.com, since they point to the same server. That’s OK.

Then I’m adding an other addon domain c.example.com and point it to the server IP. When visiting c.example.com I get the error: The requested URL / was not found on this server.

Can you tell me a reason how this could happen? I don’t get it.

What are all the spells that target undead? Or in a case does anyone know a site that can filter that

I’ve looked at the new gothic lineages and I wanted to personally look at the pros and cons of being dual as a Humanoid and an Undead/Construct or etc… and wanted to weigh out if it was worth the being an undead and being unaffected by poison and such, but vulnerable to turn undead and other targeting spells that focus on undead.

CHECK Constraint to enforce upper case letter and pattern match

For one of my columns I am trying to enforce a pattern. The first letter should be D upper case, and the remaining 3 characters should be digits. For example:

D678, D890, D000

I’m quite new with CHECK constraints and things like regular expressions.

Below is what I’ve done so far, which (I think) enforces the general pattern. However when I try adding something like d900 it works, even though it’s a lower case d. I expected this to fail.

Can someone please assist:

CREATE TABLE Systems( SystemsID NVARCHAR(4), Title NVARCHAR(30), CONSTRAINT chk_SystemsID CHECK (SystemsID LIKE '[D][0-9][0-9][0-9]')); 

Case statement query

How can this be re-written. somehow not able to make it right. In case statement Then and ELSE are same would like to change it to single statement.

SELECT t.status_id status_id, ( CASE WHEN t .status_id NOT IN (SELECT status_id FROM firm_return WHERE enabled = ‘D’ and firm_id=t.firm_id)

THEN (cl.category_code + ‘-‘ + s.status_name) ELSE cl.category_code + ‘-‘ + s.status_name END) AS status_type FROM bla bla