DCK
Tables (11)
ACADEMY
- A_NO — NUMBER — Primary key — NOT NULL
- A_NAME — VARCHAR2
- A_R_NUM — NUMBER
- A_ADDR — VARCHAR2
BROKERAGE
- B_NO — NUMBER — Primary key — NOT NULL
- ID — VARCHAR2 — Foreign key → USER.ID — NOT NULL
- A_NO — NUMBER — Foreign key → USER.A_NO — NOT NULL
- B_COMPANY — VARCHAR2
- B_CONTENT — VARCHAR2
- B_AREA — VARCHAR2
- B_W_DAY — DATE
- B_W_TIME — TIME
- B_PAY — NUMBER
- B_R_DATE — DATE
- B_L_DATE — DATE
- B_IMG — VARCHAR2
- B_FILE — VARCHAR2
BROKER_COMMET (BROKER_COMMENT)
- B_NO — NUMBER — Foreign key → BROKERAGE.B_NO — NOT NULL
- ID — VARCHAR2 — Foreign key → BROKERAGE.ID — NOT NULL
- A_NO — NUMBER — Foreign key → BROKERAGE.A_NO — NOT NULL
- B_C_RE — VARCHAR2
- B_C_LIKE — NUMBER
CERTIFICATION
- C_NO — NUMBER — Primary key — NOT NULL
- A_NO — NUMBER — Foreign key → ACADEMY.A_NO — NOT NULL
- ID — VARCHAR2 — Foreign key → USER.ID — NOT NULL
- C_N_ISSUE — VARCHAR2
- C_DATE — DATE
- C_F_NUM — NUMBER
- C_F_TIME — NUMBER
- C_SOLO — NUMBER
- C_TRAIN — NUMBER
- C_TRAINER — NUMBER
- C_TOTAL — NUMBER
- C_PURPOSE — VARCHAR2
DEAL
- D_NO — NUMBER — Primary key — NOT NULL
- ID — VARCHAR2 — Foreign key → USER.ID — NOT NULL
- A_NO — NUMBER — Foreign key → USER.A_NO — NOT NULL
- D_NAME — VARCHAR2
- D_IMG — VARCHAR2
- D_PRICE — NUMBER
- D_TYPE — VARCHAR2
- D_AREA — VARCHAR2
- D_CONTENT — VARCHAR2
- D_FIN — NUMBER
DEAL_COMMENT
- D_NO — NUMBER — Foreign key → DEAL.D_NO — NOT NULL
- ID — VARCHAR2 — Foreign key → DEAL.ID — NOT NULL
- A_NO — NUMBER — Foreign key → DEAL.A_NO — NOT NULL
- D_C_RE — VARCHAR2
- D_C_LIKE — NUMBER
FLIGHT
- F_NO — NUMBER — Primary key — NOT NULL
- ID — VARCHAR2 — Foreign key → USER.ID — NOT NULL
- A_NO — NUMBER — Foreign key → USER.A_NO — NOT NULL
- F_VIDEO — VARCHAR2
- F_DATE — DATETIME
- F_RESULT — VARCHAR2
FLIGHT_RECORD
- F_NO — NUMBER — Foreign key → FLIGHT.F_NO — NOT NULL
- ID — VARCHAR2 — Foreign key → FLIGHT.ID — NOT NULL
- A_NO — NUMBER — Foreign key → FLIGHT.A_NO — NOT NULL
- F_R_DISTANCE — NUMBER
- F_R_.... (F_R_...) — VARCHAR2
- Field3
- Field4
- Field5
- F_R_MENT — VARCHAR2
NEWS
- N_NO — NUMBER — Primary key — NOT NULL
- N_NAME — VARCHAR2
- N_IMG — VARCHAR2
- N_CONTENT — VARCHAR2
- N_LINK — VARCHAR2
USER
- ID — VARCHAR2 — Primary key — NOT NULL
- A_NO — NUMBER — Foreign key → ACADEMY.A_NO — NOT NULL
- PW — VARCHAR2
- NAME — VARCHAR2
- ADDR — VARCHAR2
- BIR — DATE
- TEL — VARCHAR2
- GENDER — VARCHAR2
- IMG — VARCHAR2
- D_LICENCE — VARCHAR2
- P_LICENCE — VARCHAR2
- U_TYPE — VARCHAR2
VEHICLE
- V_NO — NUMBER — Primary key — NOT NULL
- A_NO — NUMBER — Foreign key → ACADEMY.A_NO — NOT NULL
- C_NO — NUMBER — Foreign key → CERTIFICATION.C_NO — NOT NULL
- V_NAME — VARCHAR2
- V_REPORT — VARCHAR2
- V_DATE — DATE
- V_E_WEIGHT — NUMBER
- V_M_WEIGHT — NUMBER