musical
Tables (4)
authorities
- authority — nvarchar2(50)
- customer_id (customer_id2) — nvarchar2(50) — Foreign key → customer.customer_id
customer
- customer_id — nvarchar2(50) — Primary key
- customer_pw — nvarchar2(255) — NOT NULL
- customer_phone — nvarchar2(20)
- customer_email — nvarchar2(255)
- customer_address — nvarchar2(255)
- customer_birth — DATE
- enabled — integer — NOT NULL
persistent_logins
- username — nvarchar2(50) — NOT NULL
- series — nvarchar2(64)
- token — nvarchar2(64) — NOT NULL
- last_used — timestamp — NOT NULL
qa
- qa_id — number
- musical_id — number
- qa_type — nvarchar2(50)
- title — nvarchar2(500)
- content — varchar2(4000)
- qa_date — date
- response — varchar2(4000)
- display — NUMBER(1)
- customer_id (customer_id2) — nvarchar2(50) — Foreign key → customer.customer_id