ssafyFirst
Tables (4)
purchaseInfo(Todo) (Untitled3)
- purchaseid (Key) — char(32) — Primary key — NOT NULL
- buyer (Key2) — varchar(16) — Primary key — NOT NULL
- resultcode (Field) — varchar(16)
- purchasetype (Field2) — int
- total (Field3) — int
- purchasedate (Field4) — date
subTitleInfo(Todo) (Untitled2)
- subid (Key) — char(8) — Primary key — NOT NULL
- subname (Field) — varchar(128)
- subdiscription (Field2) — varchar(256)
- country (Field3) — varchar(128)
- runtime (Field4) — time
- registday (Field5) — date
userInfo (user)
- uid — char(8) — Primary key — NOT NULL
- email — varchar(128)
- password — varchar(128)
- create_date — datetime
userInfo(Todo) (Untitled)
- buyer (Key) — varchar(16) — Primary key — NOT NULL
- coupon (Field) — varchar(32)
- remainPoint (Field2) — int
- actTime (Field3) — time
- level (Field4) — varchar(12)